RiskGroupCounter

V8 Message Definiton

METADATA

Attribute	Value
Topic	4625-risk-counter
MLink Token	SystemData
Product	SRTrade
accessType	SELECT

Table Definition

Field	Type	Key	Default Value	Comment
riskGroupId	CHAR(19)	PRI	'0000-0000-0000-0000'
accnt	VARCHAR(16)	PRI	''
riskFirm	VARCHAR(16)	PRI	''
sysRealm	enum - SysRealm		'None'
sysEnvironment	enum - SysEnvironment		'None'	original source sys environment Stable Current etc
riskEngine	VARCHAR(32)		''	EE engine name
changeReason	enum - ChangeReason		'None'
optQtyBotIocFilled	FLOAT		0	fills IOC leaves
optQtySldIocFilled	FLOAT		0	fills IOC leaves
ddBotIocFilled	FLOAT		0	fills IOC leaves
ddSldIocFilled	FLOAT		0	fills IOC leaves
veBotIocFilled	FLOAT		0	fills IOC leaves
veSldIocFilled	FLOAT		0	fills IOC leaves
wtVeBotIocFilled	FLOAT		0	fills IOC leaves
wtVeSldIocFilled	FLOAT		0	fills IOC leaves
nvBotIocFilled	FLOAT		0	fills IOC leaves notional value
nvSldIocFilled	FLOAT		0	fills IOC leaves notional value
rm1BotIocFilled	FLOAT		0	fills IOC leaves
rm1SldIocFilled	FLOAT		0	fills IOC leaves
rm2BotIocFilled	FLOAT		0	fills IOC leaves
rm2SldIocFilled	FLOAT		0	fills IOC leaves
rm3BotIocFilled	FLOAT		0	fills IOC leaves
rm3SldIocFilled	FLOAT		0	fills IOC leaves
rm4BotIocFilled	FLOAT		0	fills IOC leaves
rm4SldIocFilled	FLOAT		0	fills IOC leaves
rm5BotIocFilled	FLOAT		0	fills IOC leaves
rm5SldIocFilled	FLOAT		0	fills IOC leaves
rm6BotIocFilled	FLOAT		0	fills IOC leaves
rm6SldIocFilled	FLOAT		0	fills IOC leaves
rm7BotIocFilled	FLOAT		0	fills IOC leaves
rm7SldIocFilled	FLOAT		0	fills IOC leaves
counter	INT		0
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
riskGroupId	1
accnt	2
riskFirm	3

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRTrade`.`MsgRiskGroupCounter` (
    `riskGroupId` CHAR(19) NOT NULL DEFAULT '0000-0000-0000-0000',
    `accnt` VARCHAR(16) NOT NULL DEFAULT '',
    `riskFirm` VARCHAR(16) NOT NULL DEFAULT '',
    `sysRealm` ENUM('None','SysTest','NMS','CME','FR2','LD4','DR') NOT NULL DEFAULT 'None',
    `sysEnvironment` ENUM('None','Neptune','Pluto','V7_Stable','V7_Latest','Saturn','Venus','Mars','SysTest','V7_Current') NOT NULL DEFAULT 'None' COMMENT 'original (source) sys environment [Stable, Current, etc]',
    `riskEngine` VARCHAR(32) NOT NULL DEFAULT '' COMMENT 'EE engine name',
    `changeReason` ENUM('None','ChildOrder','RiskExec','SymRotate','ExpRotate','AccMargin','FutRisk') NOT NULL DEFAULT 'None',
    `optQtyBotIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `optQtySldIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `ddBotIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `ddSldIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `veBotIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `veSldIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `wtVeBotIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `wtVeSldIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `nvBotIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves (notional value)',
    `nvSldIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves (notional value)',
    `rm1BotIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `rm1SldIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `rm2BotIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `rm2SldIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `rm3BotIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `rm3SldIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `rm4BotIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `rm4SldIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `rm5BotIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `rm5SldIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `rm6BotIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `rm6SldIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `rm7BotIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `rm7SldIocFilled` FLOAT NOT NULL DEFAULT 0 COMMENT 'fills + IOC leaves',
    `counter` INT NOT NULL DEFAULT 0,
    `timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000',
    CONSTRAINT nonnegative_riskGroupId CHECK(ASCII(riskGroupId) < 56),
    PRIMARY KEY USING HASH (`riskGroupId`,`accnt`,`riskFirm`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='';

SELECT TABLE EXAMPLE QUERY

SELECT
    `riskGroupId`,
    `accnt`,
    `riskFirm`,
    `sysRealm`,
    `sysEnvironment`,
    `riskEngine`,
    `changeReason`,
    `optQtyBotIocFilled`,
    `optQtySldIocFilled`,
    `ddBotIocFilled`,
    `ddSldIocFilled`,
    `veBotIocFilled`,
    `veSldIocFilled`,
    `wtVeBotIocFilled`,
    `wtVeSldIocFilled`,
    `nvBotIocFilled`,
    `nvSldIocFilled`,
    `rm1BotIocFilled`,
    `rm1SldIocFilled`,
    `rm2BotIocFilled`,
    `rm2SldIocFilled`,
    `rm3BotIocFilled`,
    `rm3SldIocFilled`,
    `rm4BotIocFilled`,
    `rm4SldIocFilled`,
    `rm5BotIocFilled`,
    `rm5SldIocFilled`,
    `rm6BotIocFilled`,
    `rm6SldIocFilled`,
    `rm7BotIocFilled`,
    `rm7SldIocFilled`,
    `counter`,
    `timestamp`
FROM `SRTrade`.`MsgRiskGroupCounter`
WHERE 
    /* Replace with a CHAR(19) */
    `riskGroupId` = 'Example_riskGroupId'
  AND
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt'
  AND
    /* Replace with a VARCHAR(16) */ 
    `riskFirm` = 'Example_riskFirm';

Doc Columns Query

SELECT * FROM SRTrade.doccolumns WHERE TABLE_NAME='RiskGroupCounter' ORDER BY ordinal_position ASC;